{\rtf1\ansi\ansicpg936\cocoartf1504\cocoasubrtf810
{\fonttbl\f0\fswiss\fcharset0 Helvetica;\f1\fnil\fcharset134 PingFangSC-Regular;\f2\fnil\fcharset0 HelveticaNeue;
\f3\fswiss\fcharset0 ArialMT;\f4\fmodern\fcharset0 CourierNewPSMT;\f5\fmodern\fcharset0 CourierNewPS-ItalicMT;
}
{\colortbl;\red255\green255\blue255;\red255\green0\blue0;\red38\green38\blue38;\red57\green57\blue57;
\red241\green233\blue220;\red251\green0\blue7;\red52\green52\blue52;\red244\green241\blue236;\red38\green38\blue38;
\red255\green255\blue255;}
{\*\expandedcolortbl;;\csgenericrgb\c100000\c0\c0;\csgenericrgb\c14902\c14902\c14902;\csgenericrgb\c22353\c22353\c22353;
\csgenericrgb\c94510\c91373\c86275;\csgenericrgb\c98431\c0\c2745;\csgenericrgb\c20392\c20392\c20392;\csgenericrgb\c95686\c94510\c92549;\cssrgb\c20000\c20000\c20000;
\cssrgb\c100000\c100000\c100000;}
\paperw11900\paperh16840\margl1440\margr1440\vieww10800\viewh8400\viewkind0
\pard\tx566\tx1133\tx1700\tx2267\tx2834\tx3401\tx3968\tx4535\tx5102\tx5669\tx6236\tx6803\pardirnatural\partightenfactor0

\f0\fs48 \cf2 [charlist]
\f1 \'d7\'d6\'b7\'fb\'c1\'d0\'d6\'d0\'b5\'c4\'c8\'ce\'ba\'ce\'a1\'b0\'b5\'a5\'d2\'bb\'a1\'b1\'d7\'d6\'b7\'fb
\f0 \
WHERE listName like \'91[ADF]%\'92
\f1 \'b1\'ed\'ca\'be
\f0 listName
\f1 \'c8\'ce\'ba\'ce\'d2\'d4
\f0 A
\f1 \'bb\'f2
\f0 D
\f1 \'bb\'f2
\f0 F
\f1 \'bf\'aa\'cd\'b7\'b5\'c4\
\

\f0 [^charlist]
\f1 \'bb\'f2
\f0 [
\f1 !
\f0 charlist]
\f1 \'b7\'c7\'d7\'d6\'b7\'fb\'c1\'d0\'d6\'d0\'b5\'c4\'c8\'ce\'d2\'e2
\f0 \'93
\f1 \'b5\'a5\'d2\'bb
\f0 \'94
\f1 \'d7\'d6\'b7\'fb
\f0 \
\
\pard\pardeftab720\partightenfactor0

\f2\fs26 \cf3 \expnd0\expndtw0\kerning0
MySQL 
\f1 \'d6\'d0\'ca\'b9\'d3\'c3
\f2  
\b REGEXP
\b0  
\f1 \'bb\'f2
\f2  
\b NOT REGEXP
\b0  
\f1 \'d4\'cb\'cb\'e3\'b7\'fb
\f2  (
\f1 \'bb\'f2
\f2  RLIKE 
\f1 \'ba\'cd
\f2  NOT RLIKE) 
\f1 \'c0\'b4\'b2\'d9\'d7\'f7\'d5\'fd\'d4\'f2\'b1\'ed\'b4\'ef\'ca\'bd\'a1\'a3\
\pard\pardeftab720\partightenfactor0

\fs30 \cf0 ^ \'c6\'a5\'c5\'e4\'d7\'d6\'b7\'fb\'b4\'ae\'b5\'c4\'bf\'aa\'ca\'bc\'b2\'bf\'b7\'d6
\f0 (
\f1 \'d3\'d6\'bd\'e1\'ba\'cf
\f0 )\

\f1 $ \'c6\'a5\'c5\'e4\'d7\'d6\'b7\'fb\'b4\'ae\'b5\'c4\'bd\'e1\'ca\'f8\'b2\'bf\'b7\'d6\'a3\'a8\'d7\'f3\'bd\'e1\'ba\'cf\'a3\'a9
\f0 \

\f1 .\'c6\'a5\'c5\'e4\'c8\'ce\'ba\'ce\'d7\'d6\'b7\'fb
\f0 ,
\f1\fs32 \cf4 \cb5 \'bf\'c9\'d2\'d4\'c6\'a5\'c5\'e4\'b3\'f6\'bb\'bb\'d0\'d0\'b7\'fb\'cd\'e2\'b5\'c4\'c8\'ce\'d2\'e2
\b \cf6 \'d2\'bb\'b8\'f6\'d7\'d6\'b7\'fb
\b0 \cf4 \'a1\'a3
\fs30 \cf0 \cb1 \'a3\'a8\'b0\'fc\'c0\'a8\'bb\'d8\'b3\'b5\'ba\'cd\'d0\'c2\'d0\'d0\'a3\'a9
\f0 \

\f1 a* \'c6\'a5\'c5\'e40\'bb\'f2\'b6\'e0\'b8\'f6a\'d7\'d6\'b7\'fb\'b5\'c4\'c8\'ce\'ba\'ce\'d0\'f2\'c1\'d0
\f0 \

\f1 a+ \'c6\'a5\'c5\'e41\'b8\'f6\'bb\'f2\'b6\'e0\'b8\'f6a\'d7\'d6\'b7\'fb\'b5\'c4\'c8\'ce\'ba\'ce\'d0\'f2\'c1\'d0
\f0 \

\f1 a? \'c6\'a5\'c5\'e40\'b8\'f6\'bb\'f21\'b8\'f6a\'d7\'d6\'b7\'fb
\f0 \

\f1 de|abc \'c6\'a5\'c5\'e4\'d0\'f2\'c1\'d0de\'bb\'f2abc\
(abc)* \'c6\'a5\'c5\'e4\'d0\'f2\'c1\'d0abc\'b5\'c40\'b8\'f6\'bb\'f2\'b6\'e0\'b8\'f6\'ca\'b5\'c0\'fd
\f0 \

\f1 \{n\}\'bb\'f2\{m,n\}\'b9\'e6\'b6\'a8\'bd\'f4\'bd\'d3\'c9\'cf\'c3\'e6\'b5\'c4\'b9\'e6\'d4\'f2\'d6\'d8\'b8\'b4\'b5\'c4\'b4\'ce\'ca\'fd\'a3\'ac\'c6\'e4\'d6\'d0\'a3\'acm\'a1\'a2n\'be\'f9\'ce\'aa\'d5\'fb\'ca\'fd\'a3\'a8\'d7\'f3\'bd\'e1\'ba\'cf\'a3\'a9
\f0 \

\f1\fs32 \cf4 \cb5 \'d5\'fd\'d4\'f2\'b1\'ed\'b4\'ef\'ca\'bd\'d6\'d0\'b5\'c4\'d7\'aa\'d2\'c6\'d7\'d6\'b7\'fb\'a3\'a8
\f3 \\
\f1 \'a3\'a9\'ba\'cd
\f3 PHP
\f1 \'d6\'d0\'b5\'c4\'b4\'f3\'cd\'ac\'d0\'a1\'d2\'ec\'a3\'ac\'b6\'bc\'ca\'c7\'bd\'ab\'cc\'d8\'ca\'e2\'d7\'d6\'b7\'fb\'a3\'a8\'c8\'e7
\f3 \'93.\'94
\f1 \'a1\'a2
\f3 \'93?\'94
\f1 \'a1\'a2
\f3 \'93\\\'94
\f1 \'b5\'c8\'a3\'a9\'b1\'e4\'ce\'aa\'c6\'d5\'cd\'a8\'b5\'c4\'d7\'d6\'b7\'fb\
\
\
\pard\pardeftab720\partightenfactor0

\b\fs33\fsmilli16800 \cf3 \cb1 \'c1\'d0\'b5\'c4
\f2  SQL 
\f1 \'b1\'f0\'c3\'fb\'d3\'ef\'b7\'a8
\f2 \
\pard\pardeftab720\partightenfactor0

\f4\b0\fs26\fsmilli13200 \cf7 \cb8 SELECT 
\f5\i column_name
\f4\i0  AS 
\f5\i alias_name
\f4\i0 \cb1 \
\cb8 FROM 
\f5\i table_name;
\f4\i0 \cb1 \
\pard\pardeftab720\partightenfactor0

\f1\b\fs33\fsmilli16800 \cf3 \'b1\'ed\'b5\'c4
\f2  SQL 
\f1 \'b1\'f0\'c3\'fb\'d3\'ef\'b7\'a8
\f2 \
\pard\pardeftab720\partightenfactor0

\f4\b0\fs26\fsmilli13200 \cf7 \cb8 SELECT 
\f5\i column_name(s)
\f4\i0 \cb1 \
\cb8 FROM 
\f5\i table_name 
\f4\i0 AS 
\f5\i alias_name;\
\pard\pardeftab720\partightenfactor0

\f4\i0 \cf3 \cb1 SELECT name, CONCAT(url, ', ', alexa, ', ', country) AS site_info\cf0 \
\cf3 FROM Websites
\f1\fs32 \cf4 \cb5 \
\
\
\pard\pardeftab720\partightenfactor0

\fs26 \cf9 \cb10 \'d3\'c3\'bb\'a7\'ce\'de\'b7\'a8\'bf\'b4\'b5\'bd\'cb\'f7\'d2\'fd\'a3\'ac\'cb\'fc\'c3\'c7\'d6\'bb\'c4\'dc\'b1\'bb\'d3\'c3\'c0\'b4\'bc\'d3\'cb\'d9\'cb\'d1\'cb\'f7
\f2 /
\f1 \'b2\'e9\'d1\'af\
\'b8\'fc\'d0\'c2\'d2\'bb\'b8\'f6\'b0\'fc\'ba\'ac\'cb\'f7\'d2\'fd\'b5\'c4\'b1\'ed\'d0\'e8\'d2\'aa\'b1\'c8\'b8\'fc\'d0\'c2\'d2\'bb\'b8\'f6\'c3\'bb\'d3\'d0\'cb\'f7\'d2\'fd\'b5\'c4\'b1\'ed\'bb\'a8\'b7\'d1\'b8\'fc\'b6\'e0\'b5\'c4\'ca\'b1\'bc\'e4\'a3\'ac\'d5\'e2\'ca\'c7\'d3\'c9\'d3\'da\'cb\'f7\'d2\'fd\'b1\'be\'c9\'ed\'d2\'b2\'d0\'e8\'d2\'aa\'b8\'fc\'d0\'c2\'a1\'a3\'d2\'f2\'b4\'cb\'a3\'ac\'c0\'ed\'cf\'eb\'b5\'c4\'d7\'f6\'b7\'a8\'ca\'c7\'bd\'f6\'bd\'f6\'d4\'da\'b3\'a3\'b3\'a3\'b1\'bb\'cb\'d1\'cb\'f7\'b5\'c4\'a1\'b1\'c1\'d0\'a1\'b1\'a3\'a8\'d2\'d4\'bc\'b0\'b1\'ed\'a3\'a9\'c9\'cf\'c3\'e6\'b4\'b4\'bd\'a8\'cb\'f7\'d2\'fd\
\
\'d4\'da\'b1\'ed\'c9\'cf\'b4\'b4\'bd\'a8\'d2\'bb\'b8\'f6\'bc\'f2\'b5\'a5\'b5\'c4\'cb\'f7\'d2\'fd\'a1\'a3\'d4\'ca\'d0\'ed\'ca\'b9\'d3\'c3\'d6\'d8\'b8\'b4\'b5\'c4\'d6\'b5
\fs32 \cf4 \cb5 \
}